2021/06/09

Agenda

  • Dataset

  • Trends and Patterns

  • Hypothesis Testing (Impact of COVID-19 on Crime Numbers)

  • Heatmap in Cities

Dataset

data.acgov.org - Alameda County Open Data Hub:

https://data.acgov.org

## Rows: 181,869
## Columns: 10
## $ DateTime         <chr> "2012/01/17 13:50:59+00", "2012/01/17 13:02:59+00", "…
## $ City             <fct> HAYWARD, CASTRO VALLEY, SAN LEANDRO, SAN LEANDRO, CAS…
## $ Longitude        <dbl> -122.1103, -122.0719, -122.1231, -122.1230, -122.0543…
## $ Latitude         <dbl> 37.67695, 37.69681, 37.70154, 37.70989, 37.70560, 37.…
## $ CrimeDescription <chr> "RECOVERED STOLEN AUTO - OUTSIDE AGENCY", "DEATH UNAT…
## $ CrimeCode        <chr> "R24", "999", "120", "999", "520", "999", "999", "23H…
## $ time             <dttm> 2012-01-17 13:50:59, 2012-01-17 13:02:59, 2012-01-17…
## $ year             <dbl> 2012, 2012, 2012, 2012, 2012, 2012, 2012, 2012, 2012,…
## $ month            <yearmon> Jan 2012, Jan 2012, Jan 2012, Jan 2012, Jan 2012,…
## $ date             <date> 2012-01-17, 2012-01-17, 2012-01-17, 2012-01-17, 2012…

Trends and Patterns

Trends and Patterns

Hypothesis Testing

Mapping

Heatmap in Cities

Heatmap in Hayward

Hayward - CrimeCode

Datatable

Thanks!